A New Technique for Database Fragmentation in Distributed Systems

نویسندگان

  • Shahidul Islam Khan
  • A. S. M. Latiful Hoque
  • C. H. Cheng
  • W. K. Lee
  • K. F. Wong
چکیده

Improving the performance of a database system is one of the key research issues now a day. Distributed processing is an effective way to improve reliability and performance of a database system. Distribution of data is a collection of fragmentation, allocation and replication processes. Previous research works provided fragmentation solution based on empirical data about the type and frequency of the queries submitted to a centralized system. These solutions are not suitable at the initial stage of a database design for a distributed system. In this paper we have presented a fragmentation technique that can be applied at the initial stage as well as in later stages of a distributed database system for partitioning the relations. Allocation of fragments is done simultaneously in our algorithm. Result shows that proposed technique can solve initial fragmentation problem of relational databases for distributed systems properly.

برای دانلود رایگان متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

A Distributed Object Based Design Technique

Distributed relational databases beneet greatly from fragmentation and allocation and these beneets should be realized in a distributed object environment. Fragmentation enhances application performance by reducing the amount of irrelevant data accessed and the amount of data transferred unnecessarily between distributed sites. This paper presents a review of early work on distributed database ...

متن کامل

Horizontal Fragmentation Technique in Distributed Database

Distributed database technology is expected to have a significant impact on data processing in the upcoming years. Today’s business environment has an increasing need for distributed database and Client/server applications as the desire for consistent, scalable, reliable and accessible information is steadily growing. Distributed processing is an effective way to improve reliability and perform...

متن کامل

Optimal Class Fragmentation Ordering in Object Oriented Databases

Distributed Object Oriented Databases require class fragmentation, performed either horizontally or vertically. Complex class relationships like aggregation and/or association are often represented as two-way references or object-links between classes. In order to obtain a good quality horizontal fragmentation, an optimal class processing order is needed. We present in this paper a new techniqu...

متن کامل

A New Data Re-Allocation Model for Distributed Database Systems

An efficient functionality of any distributed database system “DDBS” is highly dependent on its proper design in terms of the adopted fragmentation and allocation methods. However, an optimal fragmentation and allocation design techniques could be very complex and requires good experiences and knowledge to reach. Fragmentation of a large, global databases are performed by dividing the database ...

متن کامل

Security and Concurrency Control in Distributed Database System

This paper reviews the security issues and concurrency control in distributed database system. In this paper we have concerned about the features of distributed database system and its security issues. Distributed database is a collection of databases that can be stored at different computer network sites. This paper provides various aspects like fragmentation, types of fragmentation, replicati...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 2010